<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
    <style>

        #tab {
            width: 600px;
            border-radius: 5px;
            padding: 10px;
            left: 50px;
            line-height: 30px;
            position: relative;
            bottom: 10px;

        }

        .but1 {
            background-color: white;
            color: darkblue;
            border: none;
            padding: 15px 32px;
            text-align: center;
            text-decoration: none;
            display: inline-block;
            font-size: 30px;
            margin: 4px 2px;
            cursor: pointer;
            position: absolute;
            right: 20px;
            overflow: visible;
        }

        .but2 {
            background-color: white;
            color: darkblue;
            border: none;
            padding: 15px 32px;
            text-align: center;
            text-decoration: none;
            font-size: 30px;
            margin: 4px 2px;
            position: absolute;
            right: 20px;
            top: 60px;
        }
        .but3 {
            background-color: white;
            color: darkblue;
            border: none;
            padding: 15px 32px;
            text-align: center;
            text-decoration: none;
            font-size: 30px;
            margin: 4px 2px;
            position: absolute;
            right: 20px;
            top: 120px;
        }

    </style>
</head>
<body>

<a href=http://127.0.0.1:5000/all class="but1">全部信息</a>
<a href=http://127.0.0.1:5000/spj class="but2">spj关系表</a>
<a href=http://127.0.0.1:5000/search class="but3">查询</a>
<form method="post" action='{{ url_for('main') }}'>
    <h3>信息录入</h3>
    输入编号: <input type="text" name="SNO"> <br>
    输入供应商: <input type="text" name="SNAME"><br>
    请输入状态: <select name="STATUS">
    <option value="10">10</option>
    <option value="20">20</option>
    <option value="30">30</option>
    <option value="40">40</option>
</select><br>
    输入城市: <input type="text" name="CITY"><br>
    <input type="submit" value="提交">
</form>
<form id="delete" action='{{ url_for('delete_s_data') }}' method="post">
    输入预删除供应商代码：<input type="text" name="delete_data">
    <input type="submit" value="提交">
</form>
<div>
    <h1>s表</h1>
    <table border="1" id="tab">
        {% for row in data_s %}
            <tr>
                <td>{{ row[0] }}</td>
                <td>{{ row[1] }}</td>
                <td>{{ row[2] }}</td>
                <td>{{ row[3] }}</td>
            </tr>
        {% endfor %}
    </table>
</div>


<script>

</script>
</body>
</html>